Author |
Thread Statistics | Show CCP posts - 0 post(s) |

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.01.04 10:39:00 -
[1]
Edited by: Vaerah Vahrokha on 04/01/2011 10:43:10 I have some issues:
1) Speed: updating a client of mine API data takes 2 hours. With old EveTrader it takes 30 minutes, with Income Analyzer it takes 2-3 minutes (all fetch both wallet and journal). They are not native executables but .net.
2) Selecting all of the available options to clear a database and also manually deleting every character still leave a 272MB database after compaction.
3) Once the database has been cleared and populated with new characters, the autoupdater won't work, it says error accessing characters of characters not found.
EventID 1001 Event ApplicationError
Error loading characters from database
4) I tried Setup's repair. Now the app won't start any more, it says "Error accessing database at \. Application will now terminate".
Edit: restoring the .ini [Database] to before repair seems to fix the 4) - Auditing & consulting
When looking for investors, please read http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.01.05 00:40:00 -
[2]
Edited by: Vaerah Vahrokha on 05/01/2011 00:41:30
Originally by: Hel O'Ween
Did you notice where it takes the longest? EWA fetches journal, trasnactions, market orders, assets. For me market orders takes by far the longest, due to the fact that the API serves you all market orders in one XML, without the paging they implemented for transactions or assets.
The longest is when showing those count up operations. Little records people stop at around 1000 (why? Some have like 300 but it always seem to go to 1000) but once you go to 20000 the stuff really slows down to a crawl. Corp records seems slower than non corp, don't know why.
Quote:
The "base" DB is currently ca. 140 MB in size, so - yes 272 MB seems to much. Have you also cleared the application log? That can grow quite enormous ...
I opened the menu where the DB operations are located and have done all of the purges and then compact. Did I miss some other options elsewhere?
Edit: the deletions were made by setting an old date, in fact the program would prompt about confirming the operation would affect all of the data.
Quote:
The updater fetches the accounts/chars on startup. If you left him running will doing the cleanup/adding new chars, that might be the point where it got confused. It still tries to work with the old DB IDs it fetched when starting, but the chars/accounts now don't match those IDs anymore.
It was closed and not minimized. In any case even rebooting it still won't start.
- Auditing & consulting
When looking for investors, please read http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.01.20 10:42:00 -
[3]
One neat feature of JEveAssets and EveTrader is how easy is to segregate data on a per-"customer basis".
IE if I want to process data for a guy with 3 accounts I have managed (or manual in EvETrader) easy ways to keep that data in one file and totally separated to anyone else.
This seems to be peregrine but it's not, expecially because of the AutoUpdater.
First of all, as of now I have to give an Auditee his data I gathered for him but I have no idea at how to grab his 4 accounts data. Due to having to use the autoupdater to not get crazy with 30-40 manual account updates per day, his data are with other people and so how to I separate his 4 accounts (10 characters) to only give him his stuff?
Second, I did not find a way to selectively enable accounts to be updated by the autoupdater. This makes data gathering a 3 hours long cycle plus I am not authorized to gather data off people who are not authorizing me for a given period. IE an auditee wants one audit today, one in his new bond 3 months later and so on. I would not want to lose his accrued data but I cannot keep it without it being harvested with everyone else's and this could constitute auditee API infringement of access. - Auditing & consulting
When looking for investors, please read http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.02.17 13:49:00 -
[4]
Is it possible to add a "ZAP!" option somewhere? IE I press it and the DB is completely cleared of everything except the default > 100M of stuff I never understood what's doing in there to begin with. - Auditing & consulting
When looking for investors, please read http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.02.17 18:28:00 -
[5]
Stupid question: why isn't the database holding the CCP dump kept separate from the character's API data? It's kind of painful to keep a zillion copies @157MB each when a 10MB database per group of accounts would be enough. - Auditing & consulting
When looking for investors, please read http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.04.10 16:23:00 -
[6]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 10/04/2011 16:08:21 No need to apologize. It's neither your nor my fault that we're "in between forums".
I think I know what's going on: with the new patch the wallet transactions API changed to behave like the (new) wallet journal API. I've updated EWA already - alas - the forums were down, so I decided to not publish a "silent update", but rather wait until I could also announce the new update in the (new) forum. This decision was also based on the fact that the change to the wallet transactions API would be backwards compatible. Well, from your report, it seems that's not the case.
So I beg your pardon and ask for your patience. I'll upload the new version tomorrow (Monday). In case the forums are in "maintenance mode" again, simply try EWA's update function an see if it reports a new version. The auto updater is new, too. If you're using it, make sure you update both EWA and the EWAAutoData.
The same perma-loop issue struck EvE Income Analyzer, that unlike EWA, is not supported any longer. I patched EIA and posted a very long thread about how to get and install it. Of course right before CCP took the new forum offline.
If anyone wants to get a functioning version of EIA please read this page on Vahrokh.com and get it there.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.04.11 00:30:00 -
[7]
Originally by: Hel O'Ween Ha! EVE Income Analyzer. That was the tool I used until I developed EWA. And I only did that, because EIA didn't support corporations. If it had done so, EWA mostly likely were never developed. 
Good to hear that you gave some love to it. 
The fun part is that EIA supports corp wallets, it's only "just" impossible to tell it to use that because the UI never got finished. And considering it's 2.29am here and I am still far from done, I fear it won't be me to ever find the time to add new features.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.05.04 16:25:00 -
[8]
I have a problem.
Latest version, latest database, latest auto data downloader (got it manually today):
the counter runs till I read:
Processed personal wallet transaction #2560 for wallet 1000
then the status bar gets blank like it's about to go ahead but it restarts on the same wallet again and again and again (checked for 10 runs), "Update attempts" stays stuck at 0.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.05.04 21:01:00 -
[9]
The TXT logs don't show anything that looks like an error.
The EWA Extras|Application log facility reports the following repeated errors:
Event ID Event Description 201 XMLError Error -2147220988 EvE API Error: 516, failed getting user information
201 XMLError Error -2147220988 EvE API Error: 516, failed getting user information
1001 ApplicationError frmMainHelper:MainWalletInfoFill->13,EvEWalletAware, Type mismatch
Notice that the other 3 applications I am using are loading everything just fine, API keys are copied off a TXT file.
Also, transactions and journal seem to appear (I don't know if they are all) in EWA.
It's just the standalone app that hangs (no crash, just repeats the same wallet API fetch forever).
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.05.05 15:39:00 -
[10]
Since I have to run 5 API apps per high frequency auditee a day, I have to wait till tomorrow before I am able to try it again. I will tell you how it goes directly on the forum.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.05.06 07:47:00 -
[11]
Ok I gave the new app a run and it worked!
It takes about 55 minutes to process 1 character in one account but it does not hang any more.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.06.28 11:56:00 -
[12]
Does it mean that if I need to audit the last 30 days of a trader, I won't be able to see his closed orders any more?
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |

Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.06.28 17:29:00 -
[13]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 28/06/2011 15:18:27 Exactly.
Previously the API returned market orders with the following flags:
0 - Active 1 - Closed 2 - Expired/Fulfilled 3 - Cancelled 4 - Pending 5 - Character deleted
(Note: I've personally never have seen other states than Active and Expired/Fulfilled)
Due to "heavy API load", CCP - in all of its wisdom - decided to remove any market order from the API data with a state other than 0 - Active. Go figure ...
You still see the journal/transaction entries for the fulfilled past orders. But building up a market order history out of those is a bit clumsy.
Ok, so far I have called idiots 3-4 CCP departments, I'll add a fifth. How can they be so inconceivably bad 
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
|
|